abc MICROSOFT EXCEL 2010 - Pivot table

Pivot tables offer us to get better schedele of the data within one or more tables . Around Pivot table first person to work in Excel is Bill Jelen.With researching Microsoft around 60% Excel users does not know how to use pivot tables.For that reason i decided to help others to learn how to work in povot table.My help is seen in animations:

1.    Creating pivot table
2.    Data for Creating pivot table 1
3.    Creating pivot table - deviding years and months
4.    Creating pivot table - Years
5.    Rename pivot table name
6.    Adding Header
7.    Shadowing rows and colloms
8.    Showing headers of rows and colloms
   
9.    Choosing shadow color of rows and collomms
10.    Selecting data in pivot table
11.    Choosing final number of all Rows-Colloms /GRAND TOTAL/
12.    Data for creating pivot table 2
13.    Display subtotals in pivot table /SUBTOTALS/
14.    Placing Buttons in front of the header
15.    Detailed showcase
16.    Pivot Table Report Layout
17.    Deviding rows in pivot table
18.    Deleting files in pivot table
19.    Move Pivot table
20.    Changing data in pivot table
21.    Sortiranje od a do z u pivot tabeli
22.    Sortiranje u Pivot tabeli - SORT dijalog prozor
23.    Creating Pivot diagram - Pivot Chart
24.    Removing elements PIVOT CHART 2
25.    Removing elements from PIVOT CHART 3

 Index